#! /bin/bash
export LANG=zh_CN.UTF-8
PRESTO_HOME=/export/server/presto/bin/presto


${PRESTO_HOME} --catalog hive --server 192.168.88.80:8090 --execute "
create table mysql.edu_olap.apply_school_cnt as
select * from hive.edu_rpt.apply_school_cnt;

create table mysql.edu_olap.apply_type_channel_cnt as
select * from hive.edu_rpt.apply_type_channel_cnt;

create table mysql.edu_olap.apply_type_depart_cnt as
select * from hive.edu_rpt.apply_type_depart_cnt;

create table mysql.edu_olap.apply_type_intention_cnt as
select * from hive.edu_rpt.apply_type_intention_cnt;

create table mysql.edu_olap.apply_type_school_cnt as
select * from hive.edu_rpt.apply_type_school_cnt;

create table mysql.edu_olap.apply_type_school_subject_cnt as
select * from hive.edu_rpt.apply_type_school_subject_cnt;

create table mysql.edu_olap.apply_type_subject_cnt as
select * from hive.edu_rpt.apply_type_subject_cnt;

create table mysql.edu_olap.apply_type_valid_cnt as
select * from hive.edu_rpt.apply_type_valid_cnt;


"